MySQL 4.1.1-alpha-nt: problems with subqueries

MySQL 4.1.1-alpha-nt: problems with subqueries

am 09.01.2004 18:06:07 von a-m-blom

------=_NextPart_000_0004_01C3D6DB.43ACB600
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0005_01C3D6DB.43ACB600"


------=_NextPart_001_0005_01C3D6DB.43ACB600
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

=20

=20

=20

The MySQL server is stopped by Microsoft Windows XP when using one =
specific
subquery.

=20

MySQL version: 4.1.1-alpha-nt

Microsoft Windows XP Home Edition Version 5.1.2600 Service Pack 1 =
Build
2600

=20

Method to reproduce:

=20

(1a) Send batchfile from "Windows C:\ Commandprompt" window from =
directory
c:\mysql\bin with the following command:

Mysql -vvv < c:\mysql_batchfiles\select_werkverdelinginnodb_w9.txt >
c:\mysql_batchfiles\result_select_werkverdelinginnodb_w9.txt

The result in the MS-DOS command window is:

ERROR 2013 at line: lost connection to mysql server during query.

=20

(1b) Typing the same query manually gives the same result. (First =
method:
log in MySQL from "Windows C:\ Commandprompt" window. Second method: =
MySQL
Control Center 0.9.4-beta.)

=20

Information included in this mail:

=20

(1) Query batchfile and outfile mentioned above. These files, and other
MySQL files mentioned in this mail, are included in file "error report
subquery 20040109.zip".

=20

(2) Microsoft Windows XP created automatically an error report for =
automatic
transmission to Microsoft.=20

This error report is available on request, but not included in this =
mail.
(File size for "msWindowsXP_wer18_tmp_dir00.zip" is 1.2 MB)

=20

(3) Afterwards a report was made on the status of MySQL, using the tool
winmysqladmin.exe, and saved with filename "winmysqladmin report
20040109.txt".

=20

(4) The error interrupt occurred at date 2004-01-09 time 08:21 and the =
MySQL
server was started manually with NET START MYSQL at date 2004-01-09 time
08:29.

=20

(4a) Information taken from file c:\mysql\data\mysqlerr.log:
040108 21:01:44 InnoDB: Starting shutdown...

040108 21:01:46 InnoDB: Shutdown completed; log sequence number 0 =
479963

040108 21:01:46 MySql: Shutdown Complete

=20

MySql: ready for connections.

Version: '4.1.1-alpha-nt' socket: '' port: 3306

MySql: ready for connections.

Version: '4.1.1-alpha-nt' socket: '' port: 3306

=20

(4b) Information taken from file c:\mysql\data\ton-lvpcruf4206.err:

040108 20:57:04 InnoDB: Started; log sequence number 0 479963

040109 7:39:02 InnoDB: Started; log sequence number 0 479963

040109 8:29:30 InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

040109 8:29:30 InnoDB: Starting log scan based on checkpoint at

InnoDB: log sequence number 0 479973.

InnoDB: Doing recovery: scanned up to log sequence number 0 479973

040109 8:29:30 InnoDB: Flushing modified pages from the buffer pool...

040109 8:29:30 InnoDB: Started; log sequence number 0 479973



=20

=20

The MySQL server gives wrong results at other subqueries.

=20

All files mentioned below are included in the zip file "error report
subquery 20040109.zip" sent with this mail.

=20

Method to reproduce:

=20

(1) Create two databases, using the following two batchfiles:

(These two databases, and the expected results, are taken from a SQL
training book.)

create_werkverdelingInnoDB.txt

create_bibliotheekInnoDB.txt

=20

(2) Use the following two batchfiles to send the queries, and =
produce
outfiles:

Batchfiles:

select_werkverdelinginnodb_query_boek.txt

select_bibliotheekinnodb_query_boek.txt

Outfiles for MySQL 4.1.0-alpha-max-nt:

result_werkverdelinginnodb.txt

result_bibliotheekinnodb.txt

Outfiles for MySQL 4.1.1-alpha-nt:

result_select_werkverdelinginnodb_query_boek.txt

result_select_bibliotheekinnodb_query_boek.txt

=20

(3) Results for database "werkverdelinginnodb" in the Outfile:

(Query numbers can be found in the select batchfile)

Query number MySQL 4.1.0-alpha-max-nt MySQL 4.1.1-alpha-nt

W1 OK OK

W2 OK OK

W3 OK OK

W4 OK OK

W5 OK OK

W6 OK OK

W7 OK OK

W8 OK OK

W9 OK see =
remark
below

W10 OK OK

W11 OK OK

W12 OK OK

W13 OK OK

W14 OK OK

W15 OK faulty
result

W16 OK OK

W17 OK faulty
result

W18 OK OK

W19 OK faulty
result

W20 OK faulty
result

W21 OK OK

W22 OK OK

W23 OK OK

W24 OK OK

W25 OK OK

W26 OK OK

=20

Remark for query number W9: This query is changed to #comments# in the
batchfile, because it causes an error interrupt from Microsoft Windows =
XP
(as explained in the first part of this mail) when MySQL 4.1.1-alpha-nt =
is
used. The query result is OK when MySQL 4.1.0-alpha-max-nt is used.

=20

(4) Results for database "werkverdelinginnodb" when queries where =
typed
manually, using MySQL Control Center 0.9.4-beta with MySQL =
4.1.1-alpha-nt:

"ERROR 2013: Lost connection to MySQL server during query"=20

For query W9 when MySQL 4.1.1-alpha-nt and Microsoft Windows XP are =
used.

"ERROR 1235: This version of MySQL doesn't yet support 'LIMIT &
IN/ALL/ANY/SOME subquery"

For query W10, W11, W12, W15, W17, W19, W20, W21, W22, W24B, W26B.

The other results are identical to the batchfile.=20

=20

(5) Results for database "bibliotheekinnodb" in the Outfile:

(Query numbers can be found in the select batchfile)

Query number MySQL 4.1.0-alpha-max-nt MySQL 4.1.1-alpha-nt

B1 OK OK

B2 OK OK

B3 OK OK

B4 OK OK

B5 OK OK

B6 OK OK

B7 OK OK

B8 OK OK

B9 OK OK

B10 OK OK

B11 OK OK

B12 OK OK

B13 OK OK

B14 OK OK

B15 OK OK

B16 faulty result OK

B17 faulty result OK

B18 OK OK

B19 OK faulty
result

B20 faulty result faulty =
result

B21 faulty result faulty =
result

=20

The expected result for query B20 is:

bnummer bnaam
3 dokter x
7 op avontuur
8 zeilen
10 zelf sleutelen
11 elektronica

=20

The expected result for query B21 is:

boek.bnummer bnaam
10 zelf sleutelen
11 elektronica

=20

(6) Results for database "bibliotheekinnodb" when queries where =
typed
manually, using MySQL Control Center 0.9.4-beta with MySQL =
4.1.1-alpha-nt:

"ERROR 1235: This version of MySQL doesn't yet support 'LIMIT &
IN/ALL/ANY/SOME subquery"

For query B14A, B14B, B15, B16, B17, B19, B20, B21.

The other results are identical to the batchfile.=20

=20

=20

=20

Regards,

Ton Blom

a-m-blom@hetnet.nl

=20


------=_NextPart_001_0005_01C3D6DB.43ACB600
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable




charset=3Dus-ascii">












style=3D'font-size:
10.0pt;font-family:Arial'>Hello,



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'> 



lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>The MySQL =
server is
stopped by Microsoft Windows XP when using one specific =
subquery.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>MySQL version: =
4.1.1-alpha-nt



style=3D'font-size:
10.0pt;font-family:Arial'>Microsoft Windows XP Home
Edition     Version 5.1.2600 Service Pack 1 Build =
2600



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:10.0pt;font-family:Arial'>Method to =
reproduce:



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>(1a) Send batchfile from “Windows C:\
Commandprompt” window from directory c:\mysql\bin with the =
following
command:



style=3D'font-size:
10.0pt;font-family:Arial'>Mysql –vvv <
c:\mysql_batchfiles\select_werkverdelinginnodb_w9.txt >
c:\mysql_batchfiles\result_select_werkverdelinginnodb_w9.txt >



style=3D'font-size:
10.0pt;font-family:Arial'>The result in the MS-DOS command window =
is:



style=3D'font-size:
10.0pt;font-family:Arial'>ERROR 2013 at line: lost connection to mysql =
server
during query.



style=3D'font-size:
10.0pt;font-family:Arial'>        =
;   



style=3D'font-size:
10.0pt;font-family:Arial'>(1b) Typing the same query manually gives the =
same
result. (First method: log in MySQL from “Windows C:\ =
Commandprompt”
window. Second method: MySQL Control Center =
0.9.4-beta.)



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:10.0pt;font-family:Arial'>Information included in =
this mail:



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>(1) Query batchfile and outfile mentioned =
above.
These files, and other MySQL files mentioned in this mail, are included =
in file
“error report subquery 20040109.zip”.



style=3D'font-size:10.0pt;font-family:Arial'> style=3D'text-decoration:none'> 



style=3D'font-size:
10.0pt;font-family:Arial'>(2) Microsoft Windows XP created automatically =
an error
report for automatic transmission to Microsoft.



style=3D'font-size:
10.0pt;font-family:Arial'>This error report is available on request, but =
style=3D'font-weight:bold'>not included in this mail. =
(File size
for “msWindowsXP_wer18_tmp_dir00.zip” is 1.2 =
MB)



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>(3) Afterwards a report was made on the status =
of
MySQL, using the tool winmysqladmin.exe, and saved with filename
“winmysqladmin report 20040109.txt”.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>(4) The error interrupt occurred at date =
2004-01-09
time 08:21 and the MySQL server was started manually with NET START =
MYSQL at
date 2004-01-09 time 08:29.



style=3D'font-size:10.0pt;font-family:Arial'> style=3D'text-decoration:none'> 



style=3D'font-size:
10.0pt;font-family:Arial'>(4a) Information taken from file
c:\mysql\data\mysqlerr.log:

040108 21:01:44  InnoDB: Starting shutdown...



style=3D'font-size:
10.0pt;font-family:Arial'>040108 21:01:46  InnoDB: Shutdown =
completed; log
sequence number 0 479963



style=3D'font-size:
10.0pt;font-family:Arial'>040108 21:01:46  MySql: Shutdown =
Complete



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>MySql: ready for =
connections.



style=3D'font-size:10.0pt;
font-family:Arial'>Version: '4.1.1-alpha-nt'  socket: ''  =
port: 3306



style=3D'font-size:
10.0pt;font-family:Arial'>MySql: ready for =
connections.



style=3D'font-size:
10.0pt;font-family:Arial'>Version: '4.1.1-alpha-nt'  =
 size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial'>socket size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial'>:
''  port: 3306



style=3D'font-size:
10.0pt;font-family:Arial'>        =
;   



style=3D'font-size:
10.0pt;font-family:Arial'>(4b) Information taken from file
c:\mysql\data\ton-lvpcruf4206.err:



style=3D'font-size:
10.0pt;font-family:Arial'>040108 20:57:04  InnoDB: Started; log =
sequence
number 0 479963



style=3D'font-size:
10.0pt;font-family:Arial'>040109  7:39:02  InnoDB: Started; =
log
sequence number 0 479963



style=3D'font-size:
10.0pt;font-family:Arial'>040109  8:29:30  InnoDB: Database =
was not
shut down normally!



style=3D'font-size:
10.0pt;font-family:Arial'>InnoDB: Starting crash =
recovery.



style=3D'font-size:
10.0pt;font-family:Arial'>InnoDB: Reading tablespace information from =
the .ibd
files...



style=3D'font-size:
10.0pt;font-family:Arial'>InnoDB: Restoring possible half-written data =
pages
from the doublewrite



style=3D'font-size:
10.0pt;font-family:Arial'>InnoDB: buffer...



style=3D'font-size:
10.0pt;font-family:Arial'>040109  8:29:30  InnoDB: Starting =
log scan
based on checkpoint at



style=3D'font-size:
10.0pt;font-family:Arial'>InnoDB: log sequence number 0 =
479973.



style=3D'font-size:
10.0pt;font-family:Arial'>InnoDB: Doing recovery: scanned up to log =
sequence
number 0 479973



style=3D'font-size:
10.0pt;font-family:Arial'>040109  8:29:30  InnoDB: Flushing =
modified
pages from the buffer pool...



style=3D'font-size:
10.0pt;font-family:Arial'>040109  8:29:30  InnoDB: Started; =
log
sequence number 0 479973





style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'> 



lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>The MySQL =
server
gives wrong results at other subqueries.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>All files mentioned below are included in the =
zip
file “error report subquery 20040109.zip” sent with this =
mail.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:10.0pt;font-family:Arial'>Method to =
reproduce:



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'margin-left:36.0pt;text-indent:-18.0pt'> face=3DArial> style=3D'font-size:10.0pt;font-family:Arial'>(1) size=3D1 face=3D"Times New Roman"> Roman"'>    
 lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Arial'>Create two databases, using =
the
following two batchfiles:



style=3D'font-size:
10.0pt;font-family:Arial'>(These two databases, and the expected =
results, are
taken from a SQL training book.)



style=3D'font-size:
10.0pt;font-family:Arial'>create_werkverdelingInnoDB.txt >

style=3D'font-size:
10.0pt;font-family:Arial'>create_bibliotheekInnoDB.txt



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'margin-left:36.0pt;text-indent:-18.0pt'> face=3DArial> style=3D'font-size:10.0pt;font-family:Arial'>(2) size=3D1 face=3D"Times New Roman"> Roman"'>    
 lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Arial'>Use the following two =
batchfiles to
send the queries, and produce outfiles:



face=3DArial> lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Arial'>Batchfiles: >

style=3D'font-size:
10.0pt;font-family:Arial'>select_werkverdelinginnodb_query_b oek.txt >



style=3D'font-size:
10.0pt;font-family:Arial'>select_bibliotheekinnodb_query_boe k.txt<=
/font>



face=3DArial> lang=3DEN-US style=3D'font-size:10.0pt;font-family:Arial'>Outfiles for =
MySQL
4.1.0-alpha-max-nt:



style=3D'font-size:10.0pt;
font-family:Arial'>result_werkverdelinginnodb.txt



style=3D'font-size:10.0pt;
font-family:Arial'>result_bibliotheekinnodb.txt



face=3DArial> lang=3DEN-US style=3D'font-size:10.0pt;font-family:Arial'>Outfiles for =
MySQL
4.1.1-alpha-nt:



style=3D'font-size:
10.0pt;font-family:Arial'>result_select_werkverdelinginnodb_ query_boek.tx=
t



style=3D'font-size:
10.0pt;font-family:Arial'>result_select_bibliotheekinnodb_qu ery_boek.txt<=
/span>



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'margin-left:36.0pt;text-indent:-18.0pt'> face=3DArial> style=3D'font-size:10.0pt;font-family:Arial'>(3) size=3D1 face=3D"Times New Roman"> Roman"'>    
 lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Arial'>Results for database
“werkverdelinginnodb” in the Outfile:



style=3D'font-size:
10.0pt;font-family:Arial'>(Query numbers can be found in the select =
batchfile)



style=3D'font-size:
10.0pt;font-family:Arial'>Query number   MySQL =
4.1.0-alpha-max-nt        MySQL
4.1.1-alpha-nt



style=3D'font-size:10.0pt;
font-family:Arial'>W1        &nbs=
p;          =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W2        &nbs=
p;          =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W3        &nbs=
p;          =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W4        &nbs=
p;          =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W5        &nbs=
p;          =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W6        &nbs=
p;          =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:
10.0pt;font-family:Arial'>W7       &nb=
sp;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:
10.0pt;font-family:Arial'>W8       &nb=
sp;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>W9  &nb=
sp;           &nbs=
p;     =
OK            =
;            =
            &=
nbsp;     see
remark below



style=3D'font-size:10.0pt;
font-family:Arial'>W10        &nb=
sp;        =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W11        &nb=
sp;        =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W12        &nb=
sp;        =
OK            =
;       =
            &=
nbsp;           =
OK



style=3D'font-size:
10.0pt;font-family:Arial'>W13       &n=
bsp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:
10.0pt;font-family:Arial'>W14       &n=
bsp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>W15  &n=
bsp;           &nb=
sp;   =
OK            =
;            =
            &=
nbsp;     faulty
result



style=3D'font-size:
10.0pt;font-family:Arial'>W16       &n=
bsp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>W17  &n=
bsp;           &nb=
sp;   =
OK            =
;            =
            &=
nbsp;     faulty
result



style=3D'font-size:
10.0pt;font-family:Arial'>W18       &n=
bsp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>W19  &n=
bsp;           &nb=
sp;   =
OK            =
;            =
            &=
nbsp;     faulty
result



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>W20  &n=
bsp;           &nb=
sp;   =
OK            =
;            =
            &=
nbsp;     faulty
result



style=3D'font-size:
10.0pt;font-family:Arial'>W21       &n=
bsp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W22        &nb=
sp;        =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W23        &nb=
sp;        =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>W24        &nb=
sp;        =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:
10.0pt;font-family:Arial'>W25       &n=
bsp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:
10.0pt;font-family:Arial'>W26       &n=
bsp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>Remark for query number W9: This query is =
changed to
#comments# in the batchfile, because it causes an error interrupt from
Microsoft Windows XP (as explained in the first part of this mail) when =
MySQL
4.1.1-alpha-nt is used. The query result is OK when MySQL =
4.1.0-alpha-max-nt is
used.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'margin-left:36.0pt;text-indent:-18.0pt'> face=3DArial> style=3D'font-size:10.0pt;font-family:Arial'>(4) size=3D1 face=3D"Times New Roman"> Roman"'>    
 lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Arial'>Results for database
“werkverdelinginnodb” when queries where typed manually, =
using
MySQL Control Center 0.9.4-beta with MySQL =
4.1.1-alpha-nt:



style=3D'font-size:
10.0pt;font-family:Arial'>“ERROR 2013: Lost connection to MySQL =
server
during query”



style=3D'font-size:
10.0pt;font-family:Arial'>For query W9 when MySQL 4.1.1-alpha-nt and =
Microsoft
Windows XP are used.



style=3D'font-size:
10.0pt;font-family:Arial'>“ERROR 1235: This version of MySQL
doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME =
subquery”



style=3D'font-size:
10.0pt;font-family:Arial'>For query W10, W11, W12, W15, W17, W19, W20, =
W21,
W22, W24B, W26B.



style=3D'font-size:
10.0pt;font-family:Arial'>The other results are identical to the =
batchfile.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'margin-left:36.0pt;text-indent:-18.0pt'> face=3DArial> style=3D'font-size:10.0pt;font-family:Arial'>(5) size=3D1 face=3D"Times New Roman"> Roman"'>    
 lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Arial'>Results for database
“bibliotheekinnodb” in the Outfile:



style=3D'font-size:
10.0pt;font-family:Arial'>(Query numbers can be found in the select =
batchfile)



style=3D'font-size:
10.0pt;font-family:Arial'>Query number   MySQL =
4.1.0-alpha-max-nt        MySQL
4.1.1-alpha-nt



style=3D'font-size:10.0pt;
font-family:Arial'>B1        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B2        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B3        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B4        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B5        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B6        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B7        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B8        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B9        &nbs=
p;           =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B10        &nb=
sp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B11        &nb=
sp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B12        &nb=
sp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B13        &nb=
sp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B14        &nb=
sp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;
font-family:Arial'>B15        &nb=
sp;         =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>B16  &n=
bsp;           &nb=
sp;    faulty
result           &=
nbsp;           &n=
bsp;     OK



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>B17  &n=
bsp;           &nb=
sp;    faulty
result           &=
nbsp;           &n=
bsp;     OK



style=3D'font-size:
10.0pt;font-family:Arial'>B18       &n=
bsp;          =
OK            =
;            =
            &=
nbsp;     OK



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>B19  &n=
bsp;           &nb=
sp;    =
OK            =
;            =
            &=
nbsp;     size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold'>faulty result



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>B20  &n=
bsp;           &nb=
sp;    size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold'>faulty result face=3DArial> lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>   =
;            =
            &=
nbsp;  size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold'>faulty result



style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>B21  &n=
bsp;           &nb=
sp;    size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold'>faulty face=3DArial> lang=3DEN-GB =
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '> =
 size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold'>result face=3DArial> lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>   =
;            =
            &=
nbsp;  size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold'>faulty face=3DArial> lang=3DEN-GB =
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '> =
 size=3D2 face=3DArial> style=3D'font-size:10.0pt;font-family:Arial;
font-weight:bold'>result



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>The expected result for query B20 =
is:



style=3D'font-size:10.0pt;
font-family:Arial'>bnummer        =
;  bnaam

3            =
          dokter
x

7            =
          op
avontuur

8            =
          zeilen

10            =
;        zelf
sleutelen

11            =
;        =
elektronica



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>The expected result for query B21 =
is:



style=3D'font-size:10.0pt;
font-family:Arial'>boek.bnummer  bnaam

10            =
;        zelf
sleutelen

11            =
;        =
elektronica



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'margin-left:36.0pt;text-indent:-18.0pt'> face=3DArial> style=3D'font-size:10.0pt;font-family:Arial'>(6) size=3D1 face=3D"Times New Roman"> Roman"'>    
 lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Arial'>Results for database
“bibliotheekinnodb” when queries where typed manually, using =
MySQL
Control Center 0.9.4-beta with MySQL 4.1.1-alpha-nt:



style=3D'font-size:
10.0pt;font-family:Arial'> “ERROR 1235: This version of MySQL
doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME =
subquery”



style=3D'font-size:
10.0pt;font-family:Arial'>For query B14A, B14B, B15, B16, B17, B19, B20, =
B21.



style=3D'font-size:
10.0pt;font-family:Arial'>The other results are identical to the =
batchfile.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>Regards,



style=3D'font-size:10.0pt;
font-family:Arial'>Ton Blom



style=3D'font-size:
10.0pt;font-family:Arial'> lang=3DFR>a-m-blom@hetnet.nl



style=3D'font-size:10.0pt;
font-family:Arial'> 









------=_NextPart_001_0005_01C3D6DB.43ACB600--

------=_NextPart_000_0004_01C3D6DB.43ACB600
Content-Type: application/x-zip-compressed;
name="error report subquery 20040109.zip"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="error report subquery 20040109.zip"

UEsDBBQAAAAIADpSIjAlBHVYdAAAALMAAAAhAAAAc2VsZWN0X3dlcmt2ZXJk ZWxpbmdpbm5vZGJf
dzkudHh0VY5RCsMwDEP/A7mDP5OxGxR2leE2WheWOmCn7fXXlZZt+pSehGYD rdDXAk0oWcYsUlPf
eWcoGBolbtyzIUTvvu6GW64S4pWGWRXS7huIX+Ti3UPrtK8LJqh36xMKMi6s 2ejmHe0KR4OXMRxh
PDP63/iceANQSwMEFAAAAAgAWEMpMDBxe8HWAAAAXwIAACgAAAByZXN1bHRf c2VsZWN0X3dlcmt2
ZXJkZWxpbmdpbm5vZGJfdzkudHh0jZLNDsIgEITvJLzDHqlKA8aLFw++iMF2 rcRKzYI2Jj68qLVp
tf7sicDOl5kJUnaHM48lZgFyE8zaeBQJZ72NuMLZWA7NmLNLRwjtXL4qaqTd CSnH0rrCOlfl668K
DVTVYB14DCBUqnQ8ZcnNV3+3DRPp3lZOJBPIjkTowiraxL+SvVzcHbe8Jl6P Ouh9iDJLdaqlKQ9b
I12IlKlSM6m0VPMPnb1T3rqY/upixNmGqv29dYd7JM7qLRKCN6Uh62HB2SOW aBTmVIjmMXm+QZ8x
+EmW59jwFVBLAwQUAAAACAACRSkw7grBrY4NAAB+NgAAIQAAAHdpbm15c3Fs YWRtaW4gcmVwb3J0
IDIwMDQwMTA5LnR4dLWb/2/bNhbAfw+Q/0EY0LvtVruSrTi27wvQpilaLGmy JuswXA8CLTE2F0nU
KCmOh+H+9nuP1BdKIuXigHHA5kkf8cvj4/sm5X7HcucTzbgonD3JnYRE1Clz lm6dYkedn1l6fbj7
8ep1lLDU8aa+c895fHpyerKaeJOZ6/rOcj0/X89dvPaW5qFgWcF46lRtfXry nu8n93wCg1BSNFff
sWen1+Dq3SHlWQ5T6l4tNwkrCiomH6L26o1gW5aSggudvRFbkrLfiTYJuCoX 4eRlJheqrjr/TnlK
nT+cmIU0DfEXTQiLGwz+/7mgaUSj3o3/wJToExWsOOgTlR1OQAIFC0kMj+eA 8DKHX81FePQWLg4f
jfkeuIRGrEzgx45tdwhfkIJuuejBySH/LY5eOvK/ThgzmhYvnYuXzu37W/jX 5aerl44znU6xg5jk
ujhVB06+n2zKLQwU8bD6Fe5IuqUTQX8raY6r15Z7c+fcxqR44CJpe/kZdKeI qQDxknDHQJZRqwAg
9AueZAzud4b+fPH9985iCvryWsBDBQ2LUtDmNlssF6cn97wAWV3TpF352pkt PPjH+eGN8+n1Narb
9WHKUua8gzHwfyupwGw3JAc5in9erF/Ja6cnESmIfuUVXsCH7qiAjXTuClLA Rn0mMaxdu/4hfeCO
pflTb+pNSJztyCQtUM9BamMPOE7MQQd2yD0x4txf3L76cItbhPv3tWOhAvGC j4/koXw3sHk0CpR6
9HRANZ3iaQp7YcKAenMoaB4IGlL2RCPH1Fb+vOZyXI6teYuz1epMakdA0KzA 0ElC0mg4tFtRMRz9
INoYOhtQBdnE1DG0mkpJfPjdSGjUhoSPZWbtrKYo2B/D7S6ljpV1+l0qIXnR OTB9ioaPw7smKi8T
x9xqCqTO7NtUUwKM9vHZK+qhTEPd+JspBhZ1YPsH1BHZRzSmhXUbu1SQlHHB RqiRE6tRgmd2JexQ
Njl0KZscupRVoTtUmZu0RqMe4jLfmQmN2goycnJrakfApvDcJv2W4hm1no+W gv02WxSNonFmQ1qK
pSCFoxqtKLBRMZg7K/XI4nh4s0/F3D71LlWd7AD9znHKsOkNFT6q2zaDjhQH F5wwq5mrqExQOegj
PVjMvqRKsbUftA4FFhEiBIqLNM9e0JQkR8+2oBlhFnXuUDEJj1nyirJtd0Pl 9LjeA1Xg8izTb6gn
/njUMikKnJZZy2qKxzH6IiPTUDl5ggCe2U5uTVkUvmpeTRVSe0zGy2n72vF9 sGFpzLcjmqNRAYTL
/RhEp8D9CRja0FmHAnHIwH7A9agySYPikPXPSIeyuhkDZTD7OoWHGmNOawQj KSoEF2OnVlIPjMaG
UKhHSUN9lGJpyqNNkKvg1kZZjn+Psmx1j6rs15ERU7q3RDo6hd7DbOp0KhPs CRKA7VD4XYqHNM9j
SFhGqDyGkxRgfD42oqIMS+xShvuqnXkadtSUt5RJozvUExHM3J1O7YlIIb0f OWr1+sy+tEdxs2Ou
qEJAKDTwBn2qTEfdWk1lQ79io8ZDPpnpmMxI3SCTuZAnPwqKBKI+lptm53Yp y/R71AOzrfEtjckB
qCpAKXYYGA0OUU3tBeTO5gVolN3mIPUOg0J7+oUNdPU93IQsfixhcFtqJDDX KFwaiEIMjmNnREmB
efqKvlL6bA7mOhREPE/HKZGagjoDZRh1qVF25631NaLVGiV32wgh9QM9BBs8 QnmQ8kLF+r0svUtB
umCMWytKrU/Vgcy6WlPWE9RQcub2znTK3pmLJaZnOe26UGE4vqA5H9vloybK MyD4XiehrxurZxlQ
luPao/IChJHYuIpCAzAy5uL05EeU0ZhdAucxAywkkOIHIFHBaB5gBQUv6Jjb UMqaWE1ARe2YBelQ
Md8nFPOGMjU5oopCFZS/DCrWUg+CgpXWK3xWSintCFVgudCCAfUpi0fcsWwf f7q6wqIfhsiQvsdx
8Cs31nbcLiVk1WbAtpQEDP0YKEt1p6XykIyl03fSI6uoiZr9UUPBDmIQYO7r 5t075DDoI+C+d0ZX
5FS9AVUpoqmriuLgzxKKGWJGclOc3FBj8tKo7pG2UGPyktS9DKuUSWQJ1t4H pnjRpfYE7NRQr7Ev
JSOr5vcoFRGYqJlGKVNn4ryWGtlLoH7CUsBI/g7NX86w5P25CR/bMjj6Lwz9 R54+c5uC+wjlXKy/
yMr7F6BVSqjObm4sU8xn5wtwpZsyfqzjoU358ICpRY9fzpfLhQssppAklNkH xfKOrN93GyaPqTdA
D5CJ9IulZfEw6LNO876iT1Vz7/VpQRt/NoZOMDuemGTcCDYHln6pM+lX/XEE zSEm7h2bZpw6szZP
p0WDfA87jVEj058yiuboU8ZNsj6VhqUQIFVrne/mo8Rw+gEqPS+N0epZ8zrI dLdujViR/SIfAXfE
RULMITC0F79MXiSTF5GCcQYjD9Sw8+L9+gVbv4DjFtEHAlsU7Cl9tDzpIgVh DUbF9qAQBRF1s4mY
DWN3z3UHnEluc50DY19aTi30ByB9zpigsl4AamGrLB6pR2OTbkhywagJ85Y4 7ANYCM5jSkCtDmlB
DJX1753Jv/7x7Xf//dv6m2/+8od8BF8/7bmIgthcqfYVBbHnGDU7Uxw6wkMA AiBpjvrdF/pMzROT
ZtkdBpeG7r7dlCwuJiz97vRkh956Y3/tAO3jTYWF4pDZC3wtxhPIg/ovhev2 y+VdxanqkZnqcDmx
vWpytGEFYSO18gbLD0nMUlvFsx0V45w8t9Xom+7Ulgzi46rJ7ljKCttWVA0h WUojUcTQdEG4KSNh
0LjmLHiuvzw7XzRs5bA6TN0ar2VgyV4GxkFSyd5tKDRFcqYQRhW908M2eNdb e+71mpQFV58udB/d
cTBJQ7vXQLJrxo3xnt9QfCQvkqai7o2LEDO/kIOR7wX5LaXGChrzHmpkKx9l BjBqIGCjxLNejPBa
iuRwunZlEfF9/6CiTdSXmZlfs0ij0xk0ocWODzS3gWTlCsNCg+k8czUMpi4g lja4nemXAcaehtqo
Tw05S0A00ENk5ZINRvts5s+WS3fAyqxyK3ipVfdmHUreNGiUtpiEYfUJfEbD txrTbhoaV+ihOIBS
b2HgTHtJsZIzgwgGwhgQic2r4xKAxDTMKhXVvLnnnsNC0H2Ok9URdRWrYlWZ YZoe8NyZr4MRe2JG
D+B1O4QFywOQ73jcUTF5jmLIhUoy9vKtH/zRdBtDwPQFn8VsS21l57OntuGJ kB+kwF6PmD+FjWUA
CkPtxI0+UqZtuM3YtxMapwrNqleDxdG40VS04ez1b51Lt5XrsIUe+IVNrN4/ yK+5LDOsuttj/RTi
46qSj29BuyRKGU8CiRGO4CyEj4ZXks3ZRvZIHuXPVv5qcT7Dj2003KbvcDDm 5763RE1G3F5nq3C3
w9lKzV6FydsAl+bXlItq1DrMtJQcZlVvO0qqAodxPd7i/Px85lVyknbBtuyh nIQMsK2iqmaQQ5Ce
o48zF6j7nULkuC12ks+xNtH7DkAZEAQzfPuNRhMrVjTpvzWt5SQ7UZ06htb2 h1+GjOxltZqR9xfY
5jOFqWKutIKmnews+oBxobTuEIoIombc8UOzxdKfn/lniw495FSbef65v5wv /PMGVx8KmHXF0ygZ
gVSvtXvHDo9nxcmBj1UZ8OTC6WTZEQuX0qYv2y55i/nSV6QMgewpK35dq7AC g1nbGfIqTO2StbuF
xPbDG90mlwFuSZbsMF2xWEzFNTGhMdPEBqNmzJrz1K2bdhc8ncRPWSjKB3/G F1PoQBlxaU3svUwH
T8IDML7BC/bafO6COmb4hWUIsTjoTW7+FgKFXX9AMxJJVIWsLKdlVAfWgTER AoVVHgddQGiLNZbe
alaDVVHeLO/GU+gsprsQbQRl2nnEd1c90GIt3S6FL6QNFPqynEI4DwFOabZP EkPFUd2BINWqTeOq
JasS+ahsZrBkAOn4jjhtFChRnsamF4xVk5Ns3vfZu50twD75iNbOw/rdFIpH ZHGTGWHN25Dvgqxl
UBfZ3pLIJufX4QKsw8kIQ+euf7n78Qq3BStuZgWsGo4rQy40JVYjMpeh8dcK MH9kGboBKjBzxt0b
FKyl0iAGw4K1GQL97jpf3lg4/R2GOY4DLRiz+zXlrs7l9oJlChIejVmw0xMV l9hqDrKhG28/6rBR
sGsf7vBb9zpJHjmbbkNB4GD9YsxbLaQbK54DlvOYGOq8dft0eXv5+v71m6vL yafL12/hmfGCJra2
lonw7/jnFfb2M82LyWUpeEacb2HSaUSIiAr2a/QdPJ+MxXeyzednZ76PoQnA R6q5uCtwzHIigyCb
GVGWRgcthkkZTLtzaMHe3whUj8jyheUj+TteipA6EcsLwTYlTqPzHP5JBQRK 6g8utMZQEn2OD532
x/vTE0u9Qm9VTn16ckXywrli+Mb3QfDEuRSi+ZOLz2q4tfPX7kL/6jg5xwQG 7sBv9LvryrVeH+5+
i9cOaurBAW1ytNh0+mf0eHri+q7nLiGAXLve2l/AsVJP3NWVoguQFn61YkA/ pCl/+0Zjw4qN/u5g
Vpzjhw34x0NpmWyocFzHP1+tFvN+V77WFX5ZheatrlRNp4Zp+s00P+KRixv6 z5WRu56v1t7qa2TU
oP+/jP4HUEsDBBQAAAAIADZkvi4g37GyCAMAAEoJAAAeAAAAY3JlYXRlX3dl cmt2ZXJkZWxpbmdJ
bm5vREIudHh0tVXLbtswELwb8D8QyMEOoACWX7FR9JA0LfpI0TYJesiNltYW K4o0SEpp+vVdUtTD
spUWBaqLqN0ZcsUZLs/ILwYkkXIba5OnZEkKKshGQkpuqKEbqkETEOT+263L PEhBYiB3UrIf5Gw4
iBRQAyT2WPIEKi1AxcCZ2H0QQt5cvxoO8t6M5yObAylAG7bDNBkPB8Q+GBGU ZiRKqBqHk3MipCEi
5zzwgI2iIkqgBKzOq/CeU2o0qXl1XLGMqmeSwjMZ+8nrJBMx/GzCPnpOzPMe yGtS18yEBmUQbiRp
1VxQnoMeDsajewE8oftRMEqkgoji4EqJBLKRXWs8egTguTYub4Dj+5GKuJBS GY94L9MLefHgchXm
KtMG949Ws3xJfaIPcJfIWOqDKjaRzGPw+XdS7E7VOBx0hbHaCchA1cI8iTyz 3zqjHAU1R8I8Nbo1
stBtKb/XZVonti2Vm6imnCqm0XARysbbQnaNcVJgX2RX4J5w1w5b3Be2E4de IQq2oEBEeCxadu14
xj3upHDATYyojmgMnWS+j+lR8g9ua4Ro3BZa6agyVumYoZaGQT2EXOF4NZlM 8NW4qjTAFGPXSuY4
K442lDtiJEX5i8yFQ0+uTFtSZ5aaM7umkjLDEgsWWXbKsURLm59gzTHyJmGi tVqFXzm493SJXmDg
BtLUlfHynx3wlhh4i63GFrfHxmQ6nHDqONUpLUmXLVJrLQ14EIx1IX6sT2/j ysagAN5fpme6E1eS
1vj5kaK2djN6tnB5crnQBj/RvduWFPLUTZFKS1leWmH8wfdw649bdoydL7o1 hdMe6OoIaZf5LO0f
99hmeXqvQmuBrwxPhdtphUeI5tjDrUZy45izUp7Dn7Be+C7/bPHab8dNDMXF G6xzvbgQCOhvZBXm
hV7XuVWqOYOaetxqKkxfpqF02lBNbHeiVn+umtu/d6IXF1b/b92/6oAtEesO GAYL55JpEM7cYBa4
O2Q894l5sPbvcO4Gi+DSvZdBGFaDkrKu5lgHJTScVBg78rGwgodTm3Ve+w1Q SwMEFAAAAAgARD69
LuJbv1JBBAAAkA0AABwAAABjcmVhdGVfYmlibGlvdGhlZWtJbm5vREIudHh0 nVZbb+I4FH5H4j9Y
mgc6EpFICFA02odW7W5H087OLlU14s2QQ/DGsSPHaaf99XvsOORGobtIkbDP d+6fj/2JvDEgeyl3
Ua6LhMzJMxVkIyEhN1TTDc0hJyDI6q97K3mUgkRA/paS/UM+DQdbBVQDiRyW bNiGM6n3AMlXIeTN
9ZfhoHhn3+miJgfCQYAiF8MBMT8uKE3Jdk/VRTD5TITURBScj504hg16NF6h 2qKRwkgrjWr3JeOU
6v5+plhK1StJ4JVcWGcHERMR/Ko23d5nol8zIL+RQ+xM5KA0grV0oT9TXkA+ HFyMrgF0PhqP/GU4
9yZzz1/i4huoJNcKoyEBLu8lKomR8YoKXKYWPw+9ydILprhYMREDJ/4C/z8p AE5F5OC3WcZEYhVm
l97E9/wQF2uDwQ75l32N36XSBRNWZYE+Qs+f4+JR8heIycxoXG22sojAKdxJ VaKnmMHUC3xc3Mld
rgHINOzG/1DwCFRp3fcmC883KZqs9nJH/EkXv0pZVOaL4V96vsn3FlIb/mLZ RT9Jl+xiZqpjK3KP
ufEi12TZSnY46NLKMrli1UYUaYqtylPKObaux6tNi3bV7hbNxVLhOTlJI2e9 S6Rq2+59iE825ppO
pvZXWBlsMP5TMqVVZUyV/8zMefzBqWFcnmGjndAU9UYmGvP92dEzDXxieQ6i ozMzAs4gRrbEG1m8
4FrDdi8YJA5ieLOWmNCbOc22j03TizKkq2cpdFGojvTS8pTxnmPTxjX2E4O9 EoJ21CyD1sB3ZMWh
0FDqdwLzTZ1uOSRaScG2tIU4TowIeVOTIzrHDgM/iznKICZ61huidyRtckUd dp2nkM2uTSPz3Zjp
jdQcjW3cyJOaTOZbcam7sqnT/So4thwnUwWYNRhllB8hsSe3Iza8MjaukVJ9 qaFUWDGvL1445w+g
bd/DElAzyh2DHzRjdgq1AEunfc+EDYyYYGqxpZYx8J1SZs23xb6L/Dtz3tvi wFn/A3AGRTn2PavC
R8sONHUuHpB9ilFep1hjwqpC8MbivnhWN29NaWxWQSuQufOBgDualsO4jajK +I1D2UHrtAGoSvkE
amOmaQPQPz7wC1Jzt6qPD9dnyeNzGIpXepG2Lvaiv8WPHrJjw3hcO+3O5aO3 fneG76QCFovmO4Eo
2GG3xRafG+7R0nor2J99JXGkDF4e+ZZG0BEWmcmnEh71drg3Gv7K26yS/H+H H5ohdYv7Q8RfLhf2
5eE4NiYNIjkeNTFuEXqBvbDNjV5PnabBYNIEG0rax1F7DDXB1nvtPPwv9qqp VcoD+/A6Ym96GjI7
67J6ftXj7kwW1Wk+4XV+JDC3mHl2XrhnYnuInnC6aDkNver0d6btGSvLLqQV lzFg35aN6ftO7Wbl
otGuw6w+RDg7XWmrMG0qLJrBmFDLt3pj2PsNxCRsRhP07bepXip06nG4Qd43 6mKwQ/ZfUEsDBBQA
AAAIABavJDA6sZZoNAYAANgfAAApAAAAc2VsZWN0X3dlcmt2ZXJkZWxpbmdp bm5vZGJfcXVlcnlf
Ym9lay50eHTNWd1T2zgQf2eG/0EzPAQYl4tsJyHTozOBhCulkGmhvbm+3CiJ IL44EuOP0Otffytb
tiVZTlImvRYe4kja793frpwDhNCXqxE6H4+u4XE4uB+cD+5Gd2h0i+4+vIel +/EtGo7Qx/H46h18
PdjfS2OKnmm0WNFoRsOAPQaM8dnk9f5eTEM6TdCMJGRCYnp4tL9XrcLxOODs 8MhB0zSKKEv+hoM0
O3KA3o7Hl8O7+0/XqCtkHKAPn0Yf/0J/YpA5CcnsW/DPjKLuqdiUDI/RQ8SX wDdOAtDhUXKShK5O
2FcIgYIRsnTQJCJsOqcOegoJSeL9PZPh85xGtDiGzlBrziM6JS1dlPdjRRE2 k1RieRCxOV22am7r
aW7zNZX6nqKSCB2jSxqdPLN0CZ+OtpRpWy08iAWpbbmqHECkUL2ikUaDtqR4 zq0gOTthxiwA6xKa
RtLAijomIYmCGL2B4/K5ZuypZmxHN7anGBuny0PJ5Mi0olC8Urf1cc5nPDbC 29XZW8O7Xs5jxNMn
NPkXld5Q+fc0/riNdyFgTlaQVhoZeBS34U+XfmpI9zTp0YqwRyFBpmv2PctX RWR5SAqd8pQlh8dC
oFsLXV8LXd+Qnu8WBS6edVPFSh61Mk0ydtnfoaQjq8fS6GoX6Zyyndca1LR1 ZbAaiKpWZDyKzFyf
UwHb39OVKyNk1apcrkdUbkgfqzaCn32IKzrSIwv6q9a4KnTuSG8Fv+RyM4zJ A6LYCymMJ4qkteIq
mXVfZX+54BJfrvmidWQ6RO8JGNthseYcp47TNrArD+mg1wTpteO6OxocYXeB zXjDdr1JYdxblw4V
qhdldobMhFiSrwoirY+QCbRlXzC11PsWxv3vL8FKdxdGhKqbmPrriLoj/fVW hN22pr+llSr9s6Hw
nreBC13B3980a6h3M+ziTRoqUC8dbzYZBe+xIc3oba4KQqQaQMhJyVrvOIqf yk21DHMGWfHlhIwW
1SUZ2SqqOqo4teKOJnpdlYoqcqKjWmfDbX1yNTqr27V0VkbrNiuKlMlBvwax mBr11Dg20bjyj5EX
hTSZu6VAeUz3mHqGUTOBjJbt6QNDrKRQDTUFwG1lyZoENzDzrA7FmlVF5Cyt Zk1CqLpUXjX7iWsM
DF5ne1fYW+B3Dgl6EdhM3GzjRiP1Gxj2uv9vvIueNl7whIb6HPGwaYp4eMkM YUuyAkxN5xgThdf7
ycVgK4Ef5qUiNF8oDdM4qeYtBROxhomuN0Caw3w3359QMCQOkpQkAUX8aRUR yNVtJtYKmnHXCI53
bhdWNZWE0xWnUhIoQCPhpIQrR1YkTCmE6BB3ndY5XA4deXcNaPkorrGOGMGd 4gZp5ol3YVclonEa
JnC335nNw002Q6k/i70olzUDWQmtBXyzoJFdEA3YbNeB9M2s8bfMGnNkrJVM +WJmdzM/j8C3Yloq
Oeu2mEkpbYEhiz5VMuLvilOh0C6vbQJtzTT2zTT2t0jjXzEIZpU0BaERIGwI 0cKACAMSJc0g0ToF
lICPt3zxir+6Fy52BKULa+cwZgNXeJqQMCOccvYg4j8NsmUsiUu8zUg9QZoG QmbE+RJUXAVTQb0I
QUVB5luofFi5mAdMkVacP82Oy36bn+7AwpAuFpka6y3T6HqwMBIvfnWymE4j moibF3zp2z3Sh7V3
BDzOmg3rWimx8MgND1uNjuzaRWJh5uc1EN8yA2CmlYmJ/naY+CtWyKXdlBnn SgsRdxSYG9WKgfMM
cb5AcJOgIUmo+JVAVhcU0ooyBdpmKA0SlJAJDZUR1Kw1Zafqxk4nC5rrYC97 8Bw3+/Tlhu/05Sf2
s4eO08s++wVF3/FrAfzjZQE8Loe86gamMe6YHayzw7nHN4WZLUYKywdBYF+8 FIEgfAukvPRJ/Bqj
wJpQIaneKUGKPPCJKJ+8aVQvhpTXLNsoZ7aQzo4moZogE+ObvMBT2H4mBPKU IeAaA36F2znF7pDi
6Tfx+nuzniZodHY3SJmyui9Nw4Z3b1ao0n7h2gFS6RY05Hbhc6jAOW9I6Tx4 VZzwCa6n7o5GqdoP
dibUdF9SB79OGBqKSwlDSLYMQ/uk387+f2IwXliDPz0eo6vb4Qh9Htyii/HN zeB2OL68ej9CB/8B
UEsDBBQAAAAIADuVJDBsBELgQQMAAMsPAAAnAAAAc2VsZWN0X2JpYmxpb3Ro ZWVraW5ub2RiX3F1
ZXJ5X2JvZWsudHh03Vdbb9owFH5H4j8ciQcuoijmjrpVgpFqrC1RS1upe5kS 4kHW4ES5tN1+/WyS
GNsEVtSOSUMIwbF9vu98PpdQAoCvEx1Ghn5Bv46Ht8PRcKbPQJ/C7PqSmm6N KYx1uDGMyRf6s1Qs
xCEGy7Fcx4uWGD86hHi2dVoshNjF8whsMzItM8SVarGwsT7hIHQ8UqnWYR4H ASbRN7oRr7eU4LNh
nI9nt3cX0GUIJbi+028eYIQoouWa9i/nh42h12SLqUOXmOaqDgtsUT91MO0A h3V49l3TjMJi4Xvg
rcDFBAfFwvMSBzjdCWdQRoNu80TT6LtcLJjEzk7BRyhfevQMKW/x6km8mhKv fkvgVZOxT4VTLflU
WziVMqjLYe121d7tqpYXvBDhfYCxS6Muyx47Q9llT9SauWqk1DhVi8SrFYPY wNUBv+AV28CRhbMU
nS8nFoXC6J9Q8AIbB2D93HgTSXVlTv3jcGJZGdMMiFdJwg56J1rnREP80h7W 5HoyucGfyXn4sbGf
YbLpAJ4bY+qYbpRx9kTDlua0ESy8wMEsPSM8XxIHPyrp2ZciHSAhUoZl05xu sI8Esi4YEwV8adVP
zKkC2d7NKfCz+Lkfh1g2D89vQPYrCcFn63wZaVv9oy/1j4EUTFcIZu7FJKrU qm9PH6Hkn/JLHmmy
qGJu84x5H0KLwIt9VmO8QUtE5D6PNHRMJkvzySEL7h4+QEeh1xwq/LYGUcpJ IMNx0nUV5QyaKsro
cJQ05HWwTgjEi4DErnsI/CZHB/LsbSl0xDQ90kRAbVX5nqrJ3pmfgDBVHFIs wPpVkRVNjCALW1Vp
qFdzHBrcvOOaVZodhaVY0Nljgdjcs461zYrf5Lvwkmcoojz380K0BlVGm+p/ DaX8SaTykscnQr2/
rRevSnX/dnkiqG4VKG3YUoXKQxE1xflv8UmoTLosGHZZ+MUJWcrKwdTglSIL 0jKllZiEqc9yIycv
Bm/hnwHnl9VBCbyXZVOekqjVfyeVD81khCRp85qKjCC3lr1YyWvftVZVWZSZ 3dYEWWwasEPSZ7PG
TpFyhoMCvv1smTzc5Ew8Zv7/1BaKHyXFr0+m9P/4/XAKn4yrq+F0bJxPLnUo /QZQSwMEFAAAAAgA
cZUkMBtJ972LBgAASy8AAC4AAAByZXN1bHRfc2VsZWN0X2JpYmxpb3RoZWVr aW5ub2RiX3F1ZXJ5
X2JvZWsudHh07Vpbb9s2FH434P/At1xqGaJjJw6wFkjQbAXaXYBuwZCXQbYY W7BMCbokbZEfPx6R
ulEkdUmybGuIoLDIQ/LwOx/PIQ9rWdUyHsXEJ+sEuU7irJyYHB6NRzUJJjIe vbGa5c149FDphkR5
MEivvJXvBcmWkJ1HaeCuDNIYRcE98iiKSYIO7alts1/rI9CmLlss4Y5EsRfQ w6MJWqdRRGjyF1OP
dFqPVJFpW4wnFlYbVam5apT5FE+x5fjh1rFowkaZ2fbcsrFlzzVoNUfpj4VP HWc/QRuyYspOkONG
JJ6g+9B3nCQej26jYI98Qkk0Ht1vSUSEJHqHDvD56cyybfZ3MB451M17obfo 4FPA+tADI6Q19TUf
GTKZjoCrmJuDnKmaI55P/TBk/J9T3yURGwWfnzG4zyw8Yx+XfrDfBrcI2+yD ryczwwP6vPfcbFaG
wNKylxY+YR9XZM90oOjsvC7fV58Z2DDuZcTjuqFkqSp19ErUPqu4G4CvQl+n aJ95LgmB/hmg81PL
PrUwYPiRRLs4idjgaFaBlNsArINyI7Btcm7NwAifPbohPsJnvO06IsQHamZ9 rsLQozveZ7GErYXn
7OMGZJjh8FLR58cgSlJmi4wcbJ65hU/Zx++Bf082aLHk81ys1kHqEqHbhyCi uW4nbD0n1gwjqL6N
E0LQSbafpfUIDhpI2OwjeGggYrPPdQAIiHkWgBvDigmxBftpnKDzBgZDbLrs z2FBo0ndI3UntqXT
E1ZdclRD6s4jlWhqaJuBXMCn4akkpCYmCJXE0jBR0klNPUlIzTVJSE0uSXE1 mzqCOYAkx6qIVAk7
uWqPDzy9I09vVy98H+eH3o1pnJjeh8kdhI30G16z3buu4aS/GTPzTcVGLzb+ iqb7PZi1NPEEkS9k
DwKFtSt9mcWLZl7TOfZVKuuRruIphD5aHyiNUbqDyi7KCpwgWiSwHNUqm4yX WavEvE0i16N0N40x
TuWoV3FAvCzaJPJZDBJYjpMyHih3pIV/aWiKu9kF4wY9Zy9IzyACz7v6Wo4m 6/DPEbYN3KehYzuV
2unYTpR20rdvz3ZKt2/gNtIPIuxL+lNAMmWhL93zK9/5mWWzKILNEfY/7Wqf wk12dXHtqz19MjoE
ZDc1c4IL9WBGWZlb8K00j4E/0LR2ErIJIo/A6S0h6y31yO474Nbj/cS8Py/A Mi7TZwr/cFQmlUrO
l7DWGvJqwZdctuyFwpwtxTgeXbkFGcIpyr+4wUNoL5qx3Zp0U65f/hA5xkJx BqYruIB09dA0fK6i
wM3+PUE3jrMp97ao/4kBQ9x4vXVCbvaizHivDw5XqmMvaP3oE5fdDmpzwZXh knzzNuK7Odc1iVYA
f0uvYWgMoCLjPE0Oj48eH5wqt7+7Trc/YcBcA2nZVeMumm39E6yF/32aJW+i IA3hAFmkaOV5Nbfv
RiJEB4DUo3FqQyIN0AhoqJkf0AFZm2PABfLZQd06d7DJCox+QIvuQakKtA5n Hcw6lOv1unEG5I79
in+v4FZAItplQN6hWQsgtYDcaPnlj0+fEEJSvKyFRqlPkybtFzn12gQnMt28 GNEgQTT1/edfdKd1
DrHhaz7lNZ/yYvmUrm+MhkdFzhfYiB4dj7hCh/VNLNSs72XlG/TVPky+/hu0 K6o1Dsf8gq7eUm1P
nZls8aCpfrY0P04Oc0F5Zr56gcw3fBO1wjU9A27S+VSqyPApPBH7Vd4GMmzK C6luO2jG5AVO6BcO
hXx8OSZbnEP571ISTuW/huxugn7znVhIxiHb5LIk5PevvTgmNB9SJ7kASd8j G+YoNqsgvQfJ/FZd
k4Q3zJuAYfAN/peF4IVST3gfuEnjhMF1QamDtJLZO/kN8W/RZ5+kCTM01cwO /gpd+WSXRAH11mLM
mmR35B/xilTlKmZHPJml5eFSYGGkqToD8r/gancGdufVGef/xV1AkzSNkFby hXg1IO/2LD6wOJPK
8s3DKUavbPt+2LYqMnhShi6nHoRL8sWL4VDDVc6pd4w6urSKIwO/JjGwktuF 6DwkMps5196XF1Us
NUdFc3wzs6FNqyGZ2TZb5hipD6G9jlMdLFY/QePnZGLf2IpxjX6qo3l9hvoB 3TgXLybqH70QwVXO
s2yFRO77YAcU/rPZqnKnZhdqdptl6zLbHJ6vHFmzdUzOsw2NAUc9l5HOo+Lt Y6olqiIvIhGg+dLF
08+KLBJUvzL+cYwfxJ6nYLx6p5l1Xhh4efmVjEd/A1BLAwQUAAAACAAwryQw Fc0PtvAJAADzUAAA
MAAAAHJlc3VsdF9zZWxlY3Rfd2Vya3ZlcmRlbGluZ2lubm9kYl9xdWVyeV9i b2VrLnR4dO0c227j
NvY9QP6Bb04yctayFScuNgPsbFsMOi3aThddoC8LxqZjIbYUSHLSAfLxPbyJ F5GiZDuzDWDmwRR5
eDvn8NxIZjjU0+lJSdZkXqEFrvAdLsnZ+emJAQEgpyfvhq707vTkRWuI6vTS 2uKZFA9PpFiQdZrd
p1mWL+5aW8SoyJ9RmqGSVOhsdDkaQW5+TudlwtaLgd7LNM/OziM03xYFyar/ wTRJp5VZBWzGdX9i
eUavzrm7ekku48t4iNePKzzMKuhlPBolw1E8HCUenDV76Y+LC7Qs8g0soaxS wPZ9CAnvHLkaDWWG
8YZh4K7A2XwFi0ePa4yr0kH2lp6+z7N7ictVXpA5prl/FdmKbERPL+hj/jDM h/8hawZUwS8D2pQV
MA9MgwH9/CBq2oA+r/JFXjaGu5vn2wWRw/2WkfUKP7bP6Q9C1tuysob7A2eL pzwvqs4omFI6ljoh
x2GmZtiPJOojgfnTE5vAzytSkJpCt2jAlzNoJ70zp5PdRfSXTj1IcrsQaxDI RR6DOJ4egnOYNPDd
QYjsj2/gC4kqKOYT7k+GEBVCCAjRIIThDv2P++OXqoGMbEhx+ZxtN/AbGUUM 9apgSQsE6utSDQBh
SQfVRqLsFmGZ5yTBvDtKk0UKi63IthDUUq1LvMZFWqL3AC7y/TcQ/2Rajy8S 0ZwUokuRQw3p2d4X
T2Po4UORb59Zr/M8W8Lys3lKPxXUNdR9RxUYGxFoUpCKravHiDtQt9xuzgTW zm2ySUop+gy4AAhs
DZYYAvTeHZpTQxJCk5vriRtmF8NCyIT25d0DVR7R3RdUc53dn09N8E9b2bYt 19VWV68ixckEltfQ
q5KVkqms1RWqTDc3slbXpDJJBJsqtB54LNvqulOk8XXCa9tX1NSWr0epFX4C oW6i/D2KR5DeEhl3
R/ZOqrJ4wtk9RajQjeybKUcNwzWQwDHo96w6u6D4HQdxK+xw3kVjFdqGj2NH bf+trpSS4COpAtpl
WZqdnvB5nJmcKIuR3V4UNzlRVAhk4ad7nSGBlCMU8NWcOZ8ukuqum0UnUE1t BFxUXLdAuhlJ/uPJ
VFHQwAaYUIBtqiRKnJgACRT/ewWEkwDoxgS4guJvycMDjOCeg6kAIc0sgBso /kiehC3vAJhB8Q84
K0kmJzk1ACjHoR9T/sHKkisTYGwDWKuIKR5+ytcKYGrOIabL/J1LXnOZQWLF Te0d9DUuDsTmmpEs
iv22sgCgRpgcJcsrbaTW4dSYza3FEh+4tvs+5Q+D8477R5MlbtEZ2F4vCC95 tAPpNp+255R1f4jx
eZrWfA+OAq5wxcesDV7Bykw9K+t///F3ELW1zd3gu6jpZ7ns+xrItPN9LlkD 3OQ0D4+5ucvFV0e2
+juwVYOZlI8oMXSLbDG2wX9q5iJqozyyvZjay9xBL9sfPiiv/q55oelYOhii m/PXfUY8mer+Dq9T
IqdguqeoNgV0Q9Wn1Dlvsb50RkOGJtQdFxe3Ip1f3R1ZTGt0ZFoRxoxMn5oC cwNCt9B91kZgaaIj
zRFQFgG1jH5JScW3YgEiDW9B3tHAcn5HCiQTg5/wpWnu2wHJv4N71tG6Vjt2 jC5qNn7f2LWmkycW
/hV27UGt6aCxHDR1TW5HuvPNU8jUtZgKScbpsIqrXZgAN2N6WiDPY2k+d3Gn TCr/832AzN9tHqsv
e85c83UFV9tBBc3hjduYTbCVpblZKfcizNL+qhGrmCu+rCdrOvEaRepK3QwT XH9bN8yItK6kl+6w
qBSoRj7VO7oz7ap6oto4RQcKxl1DFhlprlybTs2M5M+0pLF/kxUvbHdHYcni QzmaEDj1gALMxJsO
k5HwiWxDHWvjtURNfGpceLQyP9YliHBmNbj2PncIHde7xn3OQk31TtRoEQqW 9X/bdCoMykgedPij
Laytz0VxRtDp5PRz2e20xm1R7xHL9qHZ7YP3DGqZosKFvjD+3ioCD8Gn0qvk tq0ZJFk6yGMMszQo
1DYeS/7NIRVnUBAZqEe2aGC1lk1sGe2GM2C13f0I96tKEpf8eDVSSf4QeAtH tNr3hqTGi7VRFGHs
NjsQxRtbVJo+nu5jo6VZSQqK6irXjJgnvN4SIPRZPI0GH/JyEA2k81Vn6TFw RCPrkTyQdOLz1y0p
vqCfP0WICw28XNLGi1def9Pw1naIsVlcub9NBCmmXsqH3HKkGxGkZGR4rF83 ggRIAR+osQe70en/
xB69XRjTA2/Isvriy+FisnmxgAWAf1T33FyGk3gaTIClETI0kLos07tnzqyU Bz/hRxZP8VwkU8Dm
OZDzkpsCHvcAtjx751U1nxPfPmcrJBCYhnng57ygp4DNY7MAsBn8cF6zU8Dm qWEA2DxBdN4XVMBm
iKUd2Dq0CyzQDCC2A1unfZ4F9uLnuE98plX8yd11yCNAatwGVO2Mz7+fMH2b Qq6HiOsh4FzizbP7
ewi3HqLNCeqWrz3EWg9xaYD2QFaf+LZufLqsz0EM1iYToV4DdEDDuvBTy4jB eURbjqFMiEjIsdMV
+NUPVuAzFo1rj4A1ndCmIDDhp8jzDUzxKZ3T1g9rmCJtljhaJVBCJac2moS/ YeDCLeXQV1DARWdw
ZUa7ayhgtDKbqVMV+Ji5MTKDMq5h/AubOlvGFCMguwdeRE7dQ8Z0mb+3uA8D mwD9xZq8nvGZzEGY
lN8AEPp2+7hO57gi8DlC6L+4yEDq0I+jjXe08Y423tHG62nj6YpKO/BQYZLo ikm8cRRPWGYSjdlv
IiqSaCZ+44RlrqJr9juTLWZRsodRt7f0u6jjfupUpjkZHZsmaimp9j1IQdpB CmU8o04/SJlYdROt
nXUAw7hdJrtPvW7mr6Pyw6i70tpdW3VTrV3cUmfPc6b1aY+n1dlrZ/JY5uOW OqvPwx1a9dpIPeI2
yS7KsP7o5SA4rgN1Duv1Hb+mRvt9FAZoXUQ5wPg9wnrbR/ZgU5nllHqVurwH RsSSznUQcWdVXRPT
rp90pWunMOBnymYbXMHIi28AELQYlTA830/MvR7jeSD68B7L7sd+HohuHCgp y5lwmuzMhB6Iw/Kh
mwdl7h/0tcQBeDB+Szy4LwMehZ/HJxRocTqHxoPXA/iG9pS6R2GsvI/wzouu vhfqvUcUtEbORy+G
uW+9P+fJc7/PMP2Nl+SyoeeRTLih5/GM4fM4p+q5aRhu6LmBaHiz1pN6njyv dMJY9VxpNLxc54ie
Vz3BEa1wAU1T+gDScMKt/y3AG3qeCQWn6ns+FG7oeVYUXqPnHmh4jZ53Sn5e 3Xk/9jLSbY3LFa7S
rfFl3LTwDnTS0fgHAAGnOGlzig1dnWi6Otk1KHhUAEcF8JoKACQH+roKYPZ2 FMDsalcFcHNUAIdU
AKPL2Yj9HdXAUQ0c1YBoePQDjn7Am1YDH76Q05O/AFBLAwQUAAAACABKgL4u 2c6kRW0IAAC8PAAA
HAAAAHJlc3VsdF9iaWJsaW90aGVla2lubm9kYi50eHTtW21T2zgQ/s4M/0Ez fEihmLGdN+hdO5MM
aeHgyB2hzA3fnEQknjhyzi/QdvjxJ1m2LMlS7LwAdz3UDmNZu9rV7qOVtHL2 AAB35z3Q7fcu8ONp
56bT7Qx6A9C7AoM/L/Grm/4VOO2B637//Ddc3dvdIf/28GP3vHt53r856/Uu zq+u+qdd/O6s3/98
Orj5egFaGfH8e/i39wnEIQRDd+i5fjSFcOYi5I+Hv+zunDqRM3Rw42jqoAkc M4YQenAUAQ85zvwQ
TOBw7ESHwBkHMDwEjwvPcaJwdwdLAcYncB/4c+BBBAP26nEKA5jygU+gZp20 bMM08f8ao3HQOOsK
fAS1Sx/3gGpYq/dGWtjDksr73Z0nqicAT5lEUp6ouiCtZJKe1un/99gbwwD3 Yp20LcNsG5aNK13P
n0/9e2CZuELVB6T/JzCYu+NEKh73sWEeG1YdV3pwjnVAoH0i0q+qjw0C/zEE LsJuisA788g08dNo
P3d4VZy0JZykbj/gXMr7Y4mCQpX3yRKn8G4R7LCSnC6EhD8xdqNlmC3DIva9 gMEsjALcObA5c1P/
EM+BzEENwzwxbOKggYsngQesNm27DSD0CEoTnt5i4aIZ5Wlip1qG1cCVO0KD nWodK3g++0EUYz8l
wMFyGobVwpUb33uEE9A8pnI6w5Efj2Gq25kfoEy3Oh5P3bAtQF7fhxGEoN5I 2sTxpPhcAtAiT4rR
JSAt8tz6xAKpnCaxG7YVJsID9uIwAicFG6zj0+MCvm0J3xlQU/QcioFKEZgE FBs6pcgQc0BqEFy5
p9x0GowmFmW20oBSIlKjkBDlKNLATtJJjTOJSA0siUiNJElxNXQqGrOICDni sdBVvipxa85Dqt/K
q87Ky87KcT4NbhQT+jiliVL6ICUzpH7Rz2jNfK46hnpl1yW+OkpnMpvZQxTP 55wPc7ceAvgNzgmd
7GGuJ+xlRkXf6BY07qW4fHERIVVGG9ikPvJpz82WpJAtQwmFJS9V3GSixS6l aJRRZHrkYaXQR0te
yrhAQ0uzjCKTsoTCkhc/2R4gC5gsjhQ0tar5BcuSIdl6XUgyWj8g0Xb4PRPx glgts+t2kFiOonIk
lmOkHO/lM3MbaC6b3Wth9ZXDp3B8i/GqF8/pAe+kbZh4AbFqP02A3UZwrBrY ykfb2hQJPpwdVYID
pV0bFHlb5s2PauFaBAkUIyeCEz9wIdmwRXA0RS6c/XwgK4NQuaaNygAh3hhj NY7IH2qMQ+4lBc5C
aF3Q1yJwMpacGSwk2LBeXTQcMzgsjrKK4OoFoWJE2DLisU0zdLlCvZYrj+04 TmEAdO9J0/qyWCEH
9VMI7hxnks/v9P0XbA44DkdTZ0E9zopNuc4cqlRFLtJ64cExPgsIssgBoQt/ uJO0XpR1C4MhMXcJ
13rWKKKwrkxOVUlPkfyIIj2FpweK3h3sP9OiVnY+TJ2eaSGZigdEs9iWrOdV 5iiL28842kngxwuy
3UyF6bIkhcyIbuwSR2GPB9K8QGENBMWEgc6Ggozi6bI0VfSC9mQNU+eBTFNm tl9BU7uA8abWWVpn
aJ2dxfe6fop5ZZ0xxWEnBixajllDpJZt8QnYoi2EdbvQcvX1ktyMSMuqsIJK PCtkIKoMKwVEoqAb
AuRHAMWe98zDrjTSqhcDVWIvSeUqYu9LnzLesjVv2ZqVpu8K15MUNGQCu4g1 JeWdMiAkRYwK+xif
vfki+v5vVE5s08StfXXqm59VZZenCS27IlVfhC6/7qwUuzJLSil+xVk1m/g6 y8nhaiu2k7bC0ovE
Riwg4af84JHYJz/l6maFpk9ayGGg4yCS6M/7xANyEH3OKckBoL/AxyDwh+eE KWW4wHNdpiQXB7du
GEKUdamjbBJKz4UTHC8mQz9+JJTZUV2gJLefdz62wQ/yJUKKDaWe5OLhLg4j bK4OQg7QUia373fQ
uwcDD8YR9jDSSCdhC/Q8OIsCH7mjtE+Bsrrl176SUuDVAr+qgVrYqyalHKnq xIsOrhVwWgGgFZAp
ObBCL5WPS68QFNhGT8lZ3O9Z4GdwgO5IcCDZquJ3I5qKZIUH35uwikNThskY svwhrai3z2oJ+opk
O1ZIhSYpLfp5RXYUSWQL5xIFty1z00rDsJMr1myfJAZqVnjZtslzkxtd4XBA S30pd5nmjY1kC9z5
UG16eb2S7Pqq3M3qmnOnKH550nOXyRa4Vx63wF0Yd5Ydt8gA2f4/525vpLnA zYMz+XqgjPt4I9kn
Wm5h3EQIO2+Ii7+a2+S4k0oRqSK3MO4mV9GgReSu89xtXnMyQHZyFDcjrFgc g9ngNbfVsjWxJeUu
sbnIXV8qm9N8s5hqFw9y+rWkLAmjXXtVy+7bUrRhQN8sLG4Umjac4OtNss08 Vv2iVpk22yrYBewW
WphZBKAIfhfcKHhFMLLUdXUTvO3bX2jfvrkDPr6q/XvX1/1rYNkN8wMYxMNU eACjOEAhmPtY0WhK
PnHE70Z+wH7KUDXfnXwjvZflx5Xz9JB6tdRgJD0Ev7khl+YTLHZQ3Vb5JTr/ MYXKbtzHFCRDVSE7
pQZsWvRRkPHSosonidtxOTMkbv3kHI8Y+eW8TplWK3wDsZpPM0MtS8iumVZ8 89qzeW37M5FNQssq
zj99zl6QqkjcJ2WZ+KQsiwb7LwMcVaI5byVHiVN/RqDxV7FVlVAWN5lyaljc RGLAdh58FMVxIPEe
J6BzPWXPGkjyW0Q5KVxmjerJ3zEGn4tGUeo1/KcEwfoLU8nvhc/sGHkORdX9 NGn9v82LdPNgNhsf
wFc0Q/4jwjsML54jUJMcUyNerd270MN6YwvVSjz65k6uVZD6Hw5za4WMbYQ5 dXhdrnNzaz8HxQMT
fmTcO7867YHbzhW47H/5fH7ZyzfI/wBQSwMEFAAAAAgA9m6+LiCNtP1FCgAA N0cAAB4AAAByZXN1
bHRfd2Vya3ZlcmRlbGluZ2lubm9kYi50eHTtG2tv2zjye4H+hwH6wWnqBpHj OknvUqC5ZLG72dvc
Nr07oFhgodh0YtiWspLstEB+/PEhSnwMH3Kc3N5hmQ+hpeFwOG8OqVcA8OWH czi9PL+g3bOPnz+e
frw6v4Lzn+Hql5/oo8+XP8PZOXy6vPzhR/rz1csX7O8V7X5/efnd2dXnf17A SL5Yfit/X3yAVUng
nhTzNSkmZDHLbmZZlk+u//LyxVlapdcpfT2+TbMbMmmGlGRBxhVM6vc7rynw m7dYe/PyxYMCB017
8I5A6PGOSKDI72GWUcoq2Nnf29+nvfFrZZU1ybswLfIlrElZzSjiG4PwN0iv JokOydJ0yUiH6yLN
xreE9u4WaVqVyII8mL7Ls5uaCXCbF2Scst7HIrslyxrTA3yfz9/mbz+TBQeq 6H8OtCwryhZKBge6
nNdvfECfbvNJXlrTXY/z1YTI6a4ysrhN7/w0fSFksSorY7ovaTZZ53lRRbNg xKRVxoirZnpfcrxf
M/zlC0bU2w+GNJvH97ekII2YTqAn1tTTxI32VFFjgn6IwiBFjDFTEwomEk0g DgxBGg4sHg+eiccN
ANULyTb6VhAflEBIAKG1h9gfYm4E/oHF2qRhrelsD6HxwjrXmYfLyJIUe/fZ akn/97VHXCDtgyl7
oAukeanAQWpIp8UgWXoCqexrgkrFHExSkxnlSUVWhS7KFleZLtJiVgJ9LvtB w5LMo75drBdYTzrU
ad3jLajeLS7RDimGcxouSo6LiqIgFSewNjbRBvTdaZGv7vnc4zybUg5l4xn7 GTujLfp9p+iPXKIv
V8udmm2vHTI1xNgKryccR88OuJwfKmokYCo8Azg4OjzAYaKjaeM6uizphsrg Dq6/ydHOECzJ0WOv
b4nYWDXa1i0ZHtAlWWG2boPhSL5V46tsR0fyrRpYZZNM1SNqM/FAjlVDad0G h0Px1r+iDYLnY6TT
vLhN19T76+z/AMk+bfAHFuHmjLYjqJvRxZolyIXO3PqxGjMV7ppDav7SFCCr dnYZbwcWXwUj65HW
ChTjThLkrcesTd91DA7ftRvnsJoI0TznbafGkq5vbIXkTcf6OhxWTLmhL5xx J52KLYYVgpoVaJq7
RWpqObHEIy0qEblE4J2RpktjsKCGtiNmaJq2u0LbdbqYETFOj3JswhqNYhYt mnf0xRmZzylsJDWK
g3SFYwWNHpkZ6LFnUUfsBVnXuwwvNTUaxU80aBLqjuHv+UI89vIGRm5qEsab fwlvH8kbjcVb0pvD
aJ/UZpV1DBD63C3fmGW4/ZqxgTcHRt6cUYW32vWpXoG6vyFjY9gDOG27seAo DKLp9ghSli5La+yp
BWDqdrqatWlBMtQBhvTx326pBCUAHOkAuhUiNOj2BVL9XZaDABzTxz+mWUky SeRIA2DhA36aiR/8
2fCdDjAwAYxVGGYH0rhcBgXtMoPCSuws3LW3jQxXm+u7vS3mLbg35o3tquTU WV5Z04dp4M1neLwJ
apr93UU+773GDcvhkqLtzhFRsXCKSrrr/KKNGoN4gLu0SisxZ+uZhY7z5Lvd +z9+/uh9Urt1dilk
31lgwbbwDSy6lQ+UZKzBqO751c6ncpi2/alsz6dsLhWzikOSTSe45Jfp16gk HZM+Um2KyOWNHy6o
cDYPsKV8vgtFojlScTTh3CQZ13UN9JQTTcdbhQVVZXFEht5qiBx5PefuNjJ7 nCJfbs9yqX/MSCWs
saCOLV1R51fRH/k1KUA2Dn8glqZUbbYo/viqTLfE3DLaAeyGdtdouYe3JzLc rabgwQw7mB/rCg9q
2U20UH5s6BVI3YlYxTvP2YCpB2pYDUj93pue6qh4i5f0Xz/goq6FakRP/rQO f1pXAfAVyeN50Dxu
9o61wTgKk0rhLIG4dYgNjP40Osym7cFNuteQhhYCFbk2MEiiVxvQSYMmI0bi Jit/7mTNGthqQzsx
XGMK0SxIocBVgQuHY2eh0o1DNGV/LB/xDSu6e20hho7tawPBtqzo/rWFSOIo HXY4BEr2Qb9tYUnK
qTWKvEx3QL7OSuWAljepA7te0eOeQNJSu32THN50DVQBM2Ld/7Bkq8zhKWG7 dAKEWsimaYP4rcKp
77gqyP7AeDdwy96mxSd19NzFlCa+vWN7r67iDPl1Y3t3Yu8hbdFKAxZ7QdAB NIpcToY3Q93MMoNQ
BWxPxt7I9JVLCd86dYkuneSw8V7YIxHdr0dUeP4fGfsUCl6rdU+sC6mqTZ2y 1Oae2uLkLbKihpma
zKRMl6hJCExnw98aeyVjM+c4TuBjO1/2+QP5JqdH8sswIMKQBC1VqtlrFUY3 M6xWXOYY36mylTwk
4DqGbR20t7DdZnTJiK7rfHlXfXOb94zmVAVjd5UrOes6XaxIqwE7yajfO83L Xr8nd+5Nl90Z6rNz
m768p8K4+cuKFN/g8qIPIrlOp1MGOwlc1NxohXb2ppiKZjVYD8tk/ytVxoTt YU9zz7EwBxzuayWN
Lcwf3v5QXtCNsbmxsYUBzyz5gG47qi+WR2quQTqI2FahPi8mlHa6q62ni6iO BhQVQAsw7dXJzpiF
CupHfOil5Tab1msu6G3iFrNeXkHvJ7eY9WKNn4yEWcNFesdLfyHMxiFnYIH6 sS168boF1ktUfmDj
pBS9991i1muwfmDjiBW9vd1i1o++A2ToB8gBYL2iFyBDPz93AHfS58SuyVnZ EerUDPuWtvWUh8Qs
m9VD5rEgPspz/u86tw6urYNjQ90abvWog8A9YAeX1sFVdvB9HTyfBtqBWfHH GZE3LJRgPexyENhJ
RZDzv+g0rev8mNiRAygOaJw8bWH+cJq2upukFUHkwUY0h/PUjKaM0F5fc03N ybB23OQRaTDZk6cg
n5haLdOKTjx5TwFpTOWflvH+v9Mio+Ir38P+syuaA6KLrvHu49TNARGncVKY QulGw42VzgERpXf+
U040JmGfG20rJHWJPG3PJXREuB0+DMN6rrAA9hUS/QMy0RwnmUqosAcZoYLP zT5aUIKG9iWaGOS4
EeifyXFL0D/IOnw1NVklbyOWR0Q3r/ts3WOyl7QO8nnyReuLOj1fHCL54gB1 vkPF+Q4DzvdPc47r
+SzzOKz6tpEdv9vEyI6exgd0sky3X6PpEDj82lOZ86TI75rP0Lmqra2v3aPy l9Yw8lUxJjB+/yt/
8Ns1M6vpbEHKX8cFob7jN2SWveprFT2R/fV9O3DfY+Uq3Mize/xExnSfRu19 BHC2ulvMxpRqZv6W
L/DPe4DMK/fcuBuSE1OoR82MrRidOek+s1mT1N1YTGZp/HKAxSSYsLXbjB1o qm0e0A+UlF+P/EaJ
D+12M1IvERV5vixJsZ6NWYF8vqAiggYxQzV0Y9KLejpNNqY6eUEvWTpva/r4 1O26Joppo/uasLUL
myhNnhubRuEwKLuRkyYjgs3Jak4yOXSeN3ik7PTwptJkRN0QJiPv1TANOmEy kmENk+OrNf6r24dr
zg0jxF6SlZgcn8Apvx75FZz1y+2fkKKuFfQzal2s9PgfUEsBAhQAFAAAAAgA OlIiMCUEdVh0AAAA
swAAACEAAAAAAAAAAQAAALaBAAAAAHNlbGVjdF93ZXJrdmVyZGVsaW5naW5u b2RiX3c5LnR4dFBL
AQIUABQAAAAIAFhDKTAwcXvB1gAAAF8CAAAoAAAAAAAAAAEAIAC2gbMAAABy ZXN1bHRfc2VsZWN0
X3dlcmt2ZXJkZWxpbmdpbm5vZGJfdzkudHh0UEsBAhQAFAAAAAgAAkUpMO4K wa2ODQAAfjYAACEA
AAAAAAAAAQAgALaBzwEAAHdpbm15c3FsYWRtaW4gcmVwb3J0IDIwMDQwMTA5 LnR4dFBLAQIUABQA
AAAIADZkvi4g37GyCAMAAEoJAAAeAAAAAAAAAAEAAAC2gZwPAABjcmVhdGVf d2Vya3ZlcmRlbGlu
Z0lubm9EQi50eHRQSwECFAAUAAAACABEPr0u4lu/UkEEAACQDQAAHAAAAAAA AAABAAAAtoHgEgAA
Y3JlYXRlX2JpYmxpb3RoZWVrSW5ub0RCLnR4dFBLAQIUABQAAAAIABavJDA6 sZZoNAYAANgfAAAp
AAAAAAAAAAEAIAC2gVsXAABzZWxlY3Rfd2Vya3ZlcmRlbGluZ2lubm9kYl9x dWVyeV9ib2VrLnR4
dFBLAQIUABQAAAAIADuVJDBsBELgQQMAAMsPAAAnAAAAAAAAAAEAIAC2gdYd AABzZWxlY3RfYmli
bGlvdGhlZWtpbm5vZGJfcXVlcnlfYm9lay50eHRQSwECFAAUAAAACABxlSQw G0n3vYsGAABLLwAA
LgAAAAAAAAABACAAtoFcIQAAcmVzdWx0X3NlbGVjdF9iaWJsaW90aGVla2lu bm9kYl9xdWVyeV9i
b2VrLnR4dFBLAQIUABQAAAAIADCvJDAVzQ+28AkAAPNQAAAwAAAAAAAAAAEA IAC2gTMoAAByZXN1
bHRfc2VsZWN0X3dlcmt2ZXJkZWxpbmdpbm5vZGJfcXVlcnlfYm9lay50eHRQ SwECFAAUAAAACABK
gL4u2c6kRW0IAAC8PAAAHAAAAAAAAAABAAAAtoFxMgAAcmVzdWx0X2JpYmxp b3RoZWVraW5ub2Ri
LnR4dFBLAQIUABQAAAAIAPZuvi4gjbT9RQoAADdHAAAeAAAAAAAAAAEAAAC2 gRg7AAByZXN1bHRf
d2Vya3ZlcmRlbGluZ2lubm9kYi50eHRQSwUGAAAAAAsACwCGAwAAmUUAAAAA


------=_NextPart_000_0004_01C3D6DB.43ACB600
Content-Type: text/plain; charset=us-ascii

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
------=_NextPart_000_0004_01C3D6DB.43ACB600--

Re: MySQL 4.1.1-alpha-nt: problems with subqueries

am 10.01.2004 19:56:13 von Sinisa Milivojevic

Ton Blom writes:
> Hello,
>
>

[skip]

>
>
>
> Regards,
>
> Ton Blom
>
Hi!

Thank you for your great bug report !!!

This was a genuine bug in InnoDB code and thanks to your fully
repeatable test case a crash was located and preliminary fixed.

Thanks again.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org